package com.neusoft.elmboot.mapper;

import java.util.List;

import org.apache.ibatis.annotations.*;

import com.neusoft.elmboot.po.DeliveryAddress;

@Mapper
public interface DeliveryAddressMapper {
	
	@Select("select * from deliveryAddress where userId=#{userId} order by daId")
	public List<DeliveryAddress> listDeliveryAddressByUserId(String userId);

	@Select("select * from deliveryAddress where daId=#{daId}")
	public DeliveryAddress getDeliveryAddressById(Integer daId);

	@Insert("insert into deliveryAddress values(null,#{contactName},#{contactSex},#{contactTel},#{address},#{userId})")
	public int saveDeliveryAddress(DeliveryAddress deliveryAddress);

	@Update("update deliveryAddress set contactName=#{contactName},contactSex=#{contactSex},contactTel=#{contactTel},address=#{address} where daId=#{daId}")
	public int updateDeliveryAddress(DeliveryAddress deliveryAddress);

	@Delete("delete from deliveryAddress where daId=#{daId}")
	public int removeDeliveryAddress(Integer daId);
}
//已全部解决